2016-12-19 - 11550 - Spec - Inb Delivery creation program for CHR NB POs #ProductionBreakFix #chr

SPECIFICATIONS

11550 - Spec - Inbound Delivery program for CHR NB POs


Purpose

Inbound Delivery program for CHR NB POs

Admin Info

Purpose
 Inbound Delivery Program for CHR NB POs
Requested by
 Jeffrey Mau
Spec Created By
 Adithya, Damodhier
Spec Created Date
 12-19-2016
Spec QA by
 Venkat, Adithya
Objects
 ZCHR_INB_DLV_NB
Document Status
 Complete

Estimates

Sl.No
 Activity
 Estimation in Hours
1
 Research
2
 Documentation
 04
3
 Development/ Config
 16
4
 Unit test in DEV
 12
5
 Unit test in QUA
6
 Other activity

TOTAL
 32

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
 Change Details
 Requested By
 Requested On
 Notes if any





Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
Users are not creating Inbound Delivery for NB POs, Hence GR is not happening.
Automate the Inbound Delivery creation process for CHR NB POs

In Scope:

[List the activities to be included in scope]
CHR NB POs

Out of Scope:

[Out of scope activities]
Deleted Inbound Delivery PO Lines
All other POs except NB CHR POs

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]
Create a Feeder Program ZCHR_INB_DLV_NB which shall generate the list of Purchase Orders for which Inbound Delivery has to be created.

Pull the NB Purchase Orders, which were created on or after the input date, Check if ZCHR output was triggered for the POs and ex factory date shall be less than the today's date (Date of Program execution)
Consider those POs for which Inbound Delivery shall not be created.
These List of Purchase Orders are to be passed in to the Inbound Delivery creation Program "ZSNC_INBOUND_DELV" and create the Inbound Deliveries.

Feeder Program Logic:
Go to EKKO Table and get the list of NB PO's, which were created on or after the input date (PO Created Date from).
Pass the above fetched data to NAST Table and get the list of POs for which output type ZCHR was triggered.
Pass these POs in to EKPO table and get the ex factory dates of the PO lines, Of all the lines of the PO if the earliest ex factory date is less than today's date (Date of Program execution) then consider that PO for Inbound Delivery creation.
Cross check if the PO is having Inb Delivery already created.

Note: If Inbound Deliveries are manually deleted then the Inb Delivery for those lines are to be created again manually.

Input of the Program would be PO created date:

INB DLV CHR NB1.JPG

Test Plan
[List test scenarios/cases to be executed here]
Test ID
 Test Scenario
 Expected Results
INB001
 Execute the Program
 All CHR POs which has ex factory date less than today's date then Inb Delivery shall be created for all of such POs
INB002
 SNC POs Validation
 Validate that the list of POs which Feeder program makes do not have SNC POs
INB003
 CHR Z3NB POs Validation
 Validate that the list of POs which Feeder program makes do not have CHR Z3NB POs
Solution Details
[Provide complete technical details for configuration or programming here]

Would Develop a Program "ZCHR_INB_DLV_NB" which performs the below things:

Issues

[List Issues / Bugs identified in configuration or development]
If we have ex factory date as next day then the Inbound delivery wont be created till tomorrow.
2016-01-04 - 11550 - Rel Notes - Inbound Delivery Creation Program for CHR NB POs